UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HVEwHXD39rY8REkNUZxsCYmZJThwI/Jy+p1ezZ7vNqw=' 
WHERE 
  key_id = '528eadec37e2925777f790e81ed4e0a8170a529080a7af079b99fbe8e89b9a77' 
  AND (
    token = 'HVEwHXD39rY8REkNUZxsCYmZJThwI/Jy+p1ezZ7vNqw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026