UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lv0KngdKWjsFQib3hARe5UjwumWFN1mHSuzrYfIboBc='
WHERE
key_id = '6a9245ac96295eb11b7040ce0565af5e7de5ad3a07e90d1ca0b1d9af208f70ec'
AND (
token = 'Lv0KngdKWjsFQib3hARe5UjwumWFN1mHSuzrYfIboBc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)