UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'pn61242V2Ttp+yW3C9LFPQlbsXnuO8ROHd62bQ7sXQw=' 
WHERE 
  key_id = '0e03027d0165968d9f8083eb0b6ef44d2a7d119437a8b80cd91d3926716c0dd4' 
  AND (
    token = 'pn61242V2Ttp+yW3C9LFPQlbsXnuO8ROHd62bQ7sXQw=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027