UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HM1huSjjKZJYsb86aYuTGuW73T6BKZn4IXWZCcUhvWw='
WHERE
key_id = '27fc03fd83e1c36a041957d3742f7300fc5773238fd69a4f0d4a55b5ce2a6bbd'
AND (
token = 'HM1huSjjKZJYsb86aYuTGuW73T6BKZn4IXWZCcUhvWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)