UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PxGmbzD1F/fzgzY2LRB3Pud9BVg3UWjQr9gRqeOG7i0='
WHERE
key_id = 'f4d7588506fcce0b53eba123e46ca2aa90ea697a8bc1fccb3ba20e1505ede072'
AND (
token = 'PxGmbzD1F/fzgzY2LRB3Pud9BVg3UWjQr9gRqeOG7i0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)