UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BYfu25XNCCJ2G2u8YyttQ1NucKsxz8NIFKFIR34wWg0='
WHERE
key_id = '9b1efa045386430b1d357fcba58cdd6d9243c7fee43f785215209561657c9ae2'
AND (
token = 'BYfu25XNCCJ2G2u8YyttQ1NucKsxz8NIFKFIR34wWg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)