UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '4nXcmrEW34j165LZ2DnCsf+qdag1DAFQTjtp0c11ImA=' 
WHERE 
  key_id = 'cb223bc3371e6d328db4dcb1b51e6f097106f75c9e4da500ff1690702e9697f4' 
  AND (
    token = '4nXcmrEW34j165LZ2DnCsf+qdag1DAFQTjtp0c11ImA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00048