UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BhkVqgoaxd7MQI0OPVYaiqs0v/x9HHeLIgjWeOgwdYs='
WHERE
key_id = 'c702bc2d1b9e3d15f5cf8ee45e957ebf3eb904551793763c675703fb1e3a4307'
AND (
token = 'BhkVqgoaxd7MQI0OPVYaiqs0v/x9HHeLIgjWeOgwdYs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)