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