UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q7xrfE06pxp6gjA10ghtrS4yP1ACd2ZYiyNgaAqpXx4='
WHERE
key_id = '5ec24e04b6573d893f9978dce3400606ecd12c935f92d1f63de75b9673bb6723'
AND (
token = 'q7xrfE06pxp6gjA10ghtrS4yP1ACd2ZYiyNgaAqpXx4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)