UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i/yD169B/tfLOLyDMkJzAf7rbiqs9736JIuIy0kLzxk='
WHERE
key_id = '8f47011d3ca6eae12fcffb2e09933e789ef7cac65f0e46802253556571e9faec'
AND (
token = 'i/yD169B/tfLOLyDMkJzAf7rbiqs9736JIuIy0kLzxk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)