UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cxrI3OSRyhuY9ifTgefnl1jZngF3HD13e+EpVk1xsFY='
WHERE
key_id = '0bc0568ecfeb0153ea538fc012ae31292ec366d5d1793a16b49652c842f2c88c'
AND (
token = 'cxrI3OSRyhuY9ifTgefnl1jZngF3HD13e+EpVk1xsFY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)