UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'GHtq7k1dnYIEYOFKCjFmbEghsqU/4CbqF2VHI1VHZuA=' 
WHERE 
  key_id = 'ac414e154e8ca34e3e92fd75d352c7342dbc85678a2a59910ca0752da6ccd285' 
  AND (
    token = 'GHtq7k1dnYIEYOFKCjFmbEghsqU/4CbqF2VHI1VHZuA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034