UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cHKf/yor6dQ6M4o3AqZtRZAZc0jyPGWJi0ZxgF6izjY='
WHERE
key_id = '470b0fe4e765feb9e3b54ba3e5ff8eb59b72b89b71e30a56f4ad1d0bbb385fc8'
AND (
token = 'cHKf/yor6dQ6M4o3AqZtRZAZc0jyPGWJi0ZxgF6izjY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)