UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pC1X+F7bJKHTzgBNi1JEO8+LTGEia4UMoi6FSp2NIj8='
WHERE
key_id = '4a10f83fc40aa445820586c63d9aab897f22ba6209b78484991d9246a1253f9c'
AND (
token = 'pC1X+F7bJKHTzgBNi1JEO8+LTGEia4UMoi6FSp2NIj8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)