UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'O2soUhqvroxc7pwoQxQmOZcaVOtzcvGr9NEpMYJC8VY='
WHERE
key_id = '31b8193dc3f187c4ba7c8f6ab344dc36fe4f8ba192dbaf3269a45586b2a2349e'
AND (
token = 'O2soUhqvroxc7pwoQxQmOZcaVOtzcvGr9NEpMYJC8VY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)