UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X8o5p2eZMjy+hGVwlkxxUHL5eQpLfpi6YVaM4ZQmxzg='
WHERE
key_id = '4b48b75266da5bc576bdc30fc5e560344a0aa2fb68d016a0846349561aa722d2'
AND (
token = 'X8o5p2eZMjy+hGVwlkxxUHL5eQpLfpi6YVaM4ZQmxzg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)