UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ma9+tyg4K7lhQ46QGJTRmYj54aThhbooG61Ao2Bd20s=' 
WHERE 
  key_id = 'afbece6ccbc58447dd05903e18fe97c8f937cb2ed35f119bb03f54e5b4119093' 
  AND (
    token = 'ma9+tyg4K7lhQ46QGJTRmYj54aThhbooG61Ao2Bd20s=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023