UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'n/QoNZczBv3GGFSD05qmavBtVDIlNcv7MnPrhBTsEAM=' 
WHERE 
  key_id = 'd6652d8b42580f658579fd167c567eee9a154f5c3bb7199fa91b2b0ff80f2edc' 
  AND (
    token = 'n/QoNZczBv3GGFSD05qmavBtVDIlNcv7MnPrhBTsEAM=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00026