UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zZ3fxlzS4lXbyfDo8iJZgo+k/OWb6adK8zwBSJUJPxQ='
WHERE
key_id = '1898281720f4d31ee5bad71d582a3de43caf533a014259eee06261ff4baa2b27'
AND (
token = 'zZ3fxlzS4lXbyfDo8iJZgo+k/OWb6adK8zwBSJUJPxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)