UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'h3u/k0E1zy8ZM9Zjhq60OE1lWwJ1ciaNpv/YUgsXFFM=' 
WHERE 
  key_id = 'bede97a3d42667897532d4fc7d271487f0a3b2703866613e9566a19ce2acce2b' 
  AND (
    token = 'h3u/k0E1zy8ZM9Zjhq60OE1lWwJ1ciaNpv/YUgsXFFM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00027