UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SpiB2FZnBtBnI4Itcc6Gh2faLY/kap+g2LDZEyuXvwE='
WHERE
key_id = 'f9043958f84f77e96a15cc5a3bc8eb83efe9362b383c83a09a2b047c0ac155c0'
AND (
token = 'SpiB2FZnBtBnI4Itcc6Gh2faLY/kap+g2LDZEyuXvwE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)