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