UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KrNoC2X2OjV7X9mKierkmY7KeIPlirzS7dEobg8//cE='
WHERE
key_id = '497c1fc79b9504124dd53efd681f5421da283c52aa53d93976916b810b438307'
AND (
token = 'KrNoC2X2OjV7X9mKierkmY7KeIPlirzS7dEobg8//cE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)