UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RtAtB0Lm3GB546MS5HJOr+kbCZIv2fqIDzw5SvI3l+E='
WHERE
key_id = 'fcc21bea7b9e43f1cb52efd10ba539bea26af4ea1020f48cb6522eeed293ebf0'
AND (
token = 'RtAtB0Lm3GB546MS5HJOr+kbCZIv2fqIDzw5SvI3l+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)