UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'awqWTJFLPzUwVkJ7CJpgbUHtxwte3bvgD9hHitdOJC8='
WHERE
key_id = 'dd75173a5cdf2b1c37d59e40990933510e48a05d9bfdc6be86663a8e8778211c'
AND (
token = 'awqWTJFLPzUwVkJ7CJpgbUHtxwte3bvgD9hHitdOJC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)