UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'WFfF2pcOGoT/2c8Of0ZnKmlUtp1W3VCKHYznCIkbDFk=' 
WHERE 
  key_id = '93b2df353d9cbc4905d8c7e5e5d0eeaa84744a4993ef3d2d75100d5d863998f1' 
  AND (
    token = 'WFfF2pcOGoT/2c8Of0ZnKmlUtp1W3VCKHYznCIkbDFk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025