UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'DbW3d17mg6zWQhQR1rm/6IHU1LAfoANxpomNH3g/P6E=' 
WHERE 
  key_id = '1a2e93245bde876a5f6606a87cb49cc6824624706964aefe94c94107ba6c6198' 
  AND (
    token = 'DbW3d17mg6zWQhQR1rm/6IHU1LAfoANxpomNH3g/P6E=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026