UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'NOahkl3t0YsENTbqQV42WTE84MCD5ZF6Ek24qBB/J34=' 
WHERE 
  key_id = '48c8cc5f620525bf04c4a76c3f291399b57064735651861d5752f5ef38db5125' 
  AND (
    token = 'NOahkl3t0YsENTbqQV42WTE84MCD5ZF6Ek24qBB/J34=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00043