UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'wKsVRI9G6m2+vAuZTCDoi9CTtNS4M00xP7Gy1ZZ6J4I=' 
WHERE 
  key_id = '4a72e07d56cc794dbc2ac5a215307e38279124d53177a30c524837f1e93c895f' 
  AND (
    token = 'wKsVRI9G6m2+vAuZTCDoi9CTtNS4M00xP7Gy1ZZ6J4I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033