UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z1ptu8iOjyJ7dXxCVnYTJd22fHnrWcDEGEbdekoH9uA='
WHERE
key_id = 'd5a5a02e8f146882903f1fa9edeac287d1a526f6809d3a31d75f2958b4f997f2'
AND (
token = 'z1ptu8iOjyJ7dXxCVnYTJd22fHnrWcDEGEbdekoH9uA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)