UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'SxINqn8B4RPqu3L+97w3cL19G6VMjR8HI1GYnRT+VCY=' 
WHERE 
  key_id = 'b2f33a5bffb1d786e0b263917c91f3d2f12899f803e38df6bce9bff166341f08' 
  AND (
    token = 'SxINqn8B4RPqu3L+97w3cL19G6VMjR8HI1GYnRT+VCY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00036